object fmInvoiceList: TfmInvoiceList
  Left = 0
  Top = 0
  Caption = 'Invoice List'
  ClientHeight = 542
  ClientWidth = 773
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Visible = True
  WindowState = wsMaximized
  OnClose = FormClose
  OnCreate = FormCreate
  DesignSize = (
    773
    542)
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 8
    Top = 8
    Width = 35
    Height = 13
    Caption = '&Invoice'
  end
  object Label2: TLabel
    Left = 8
    Top = 189
    Width = 32
    Height = 13
    Caption = '&Details'
  end
  object Label3: TLabel
    Left = 680
    Top = 249
    Width = 22
    Height = 13
    Anchors = [akTop, akRight]
    Caption = '&Year'
  end
  object Label4: TLabel
    Left = 680
    Top = 277
    Width = 30
    Height = 13
    Anchors = [akTop, akRight]
    Caption = '&Month'
  end
  object btnClose: TButton
    Left = 680
    Top = 8
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = '&Close'
    TabOrder = 0
    OnClick = btnCloseClick
  end
  object btnPreview: TButton
    Left = 680
    Top = 392
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = '&Preview'
    TabOrder = 1
    OnClick = btnPreviewClick
  end
  object DBGrid1: TDBGrid
    Left = 8
    Top = 27
    Width = 657
    Height = 318
    Anchors = [akLeft, akTop, akRight, akBottom]
    DataSource = DataModule1.dsInvoiceList
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgMultiSelect, dgTitleClick, dgTitleHotTrack]
    ReadOnly = True
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    OnCellClick = DBGrid1CellClick
    OnDblClick = DBGrid1DblClick
    OnKeyPress = DBGrid1KeyPress
    OnTitleClick = DBGrid1TitleClick
    Columns = <
      item
        Expanded = False
        FieldName = 'INVOICE_NO'
        Title.Caption = 'Invoice No.'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'JOBSHEET_NO'
        Title.Caption = 'Job Sheet No.'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PO_NO'
        Title.Caption = 'PO No.'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'DATE_OF_SHOOT'
        Title.Caption = 'Date of Shoot'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'INVOICE_DATE'
        Title.Caption = 'Invoice Date'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'INVOICE_DUE_DATE'
        Title.Caption = 'Due Date'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'COMPANY_NAME'
        Title.Caption = 'Company Name'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 145
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'FOR'
        Title.Caption = 'Summary'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 248
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PUBLISH_ON'
        Title.Caption = 'Publish On'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 90
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PERSON_IN_CHARGE'
        Title.Caption = 'Person In Charge'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 110
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'TOTAL_AMOUNT'
        Title.Caption = 'Total Amount'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 85
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'UPDATE_DATE'
        Title.Caption = 'Update On'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 125
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PAID'
        Title.Caption = 'Paid'
        Width = 30
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'FOR_PRODUCT'
        Title.Caption = 'Magazine'
        Width = 100
        Visible = True
      end>
  end
  object DBGrid2: TDBGrid
    Left = 8
    Top = 372
    Width = 657
    Height = 143
    Anchors = [akLeft, akRight, akBottom]
    DataSource = DataModule1.dsInvoiceDetails
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    OnCellClick = DBGrid2CellClick
    Columns = <
      item
        Expanded = False
        FieldName = 'DESCRIPTION'
        Title.Caption = 'Description'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 500
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'AMOUNT'
        Title.Caption = 'Amount'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'FOC_DI'
        Title.Caption = 'FOC'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -11
        Title.Font.Name = 'Tahoma'
        Title.Font.Style = [fsBold]
        Width = 30
        Visible = True
      end>
  end
  object btnPrint: TButton
    Left = 680
    Top = 423
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = '&Print'
    TabOrder = 4
    OnClick = btnPrintClick
  end
  object rbInvoice: TRadioButton
    Left = 680
    Top = 56
    Width = 57
    Height = 17
    Anchors = [akTop, akRight]
    Caption = '&Invoice'
    Checked = True
    TabOrder = 5
    TabStop = True
    OnClick = rbInvoiceClick
  end
  object rbInvoiceList: TRadioButton
    Left = 680
    Top = 102
    Width = 75
    Height = 17
    Anchors = [akTop, akRight]
    Caption = 'Invoice &List'
    TabOrder = 6
    OnClick = rbInvoiceListClick
  end
  object txtYear: TEdit
    Left = 708
    Top = 246
    Width = 41
    Height = 21
    Anchors = [akTop, akRight]
    MaxLength = 4
    NumbersOnly = True
    TabOrder = 7
    Text = '2010'
    OnChange = txtYearChange
  end
  object txtMonth: TEdit
    Left = 716
    Top = 274
    Width = 30
    Height = 21
    Anchors = [akTop, akRight]
    NumbersOnly = True
    TabOrder = 8
    Text = '1'
    OnChange = txtMonthChange
  end
  object UpDown1: TUpDown
    Left = 749
    Top = 246
    Width = 17
    Height = 21
    Anchors = [akTop, akRight]
    Associate = txtYear
    Min = 2010
    Max = 2050
    Position = 2010
    TabOrder = 9
    Thousands = False
  end
  object UpDown2: TUpDown
    Left = 746
    Top = 274
    Width = 17
    Height = 21
    Anchors = [akTop, akRight]
    Associate = txtMonth
    Min = 1
    Max = 12
    Position = 1
    TabOrder = 10
    Thousands = False
  end
  object btnEdit: TButton
    Left = 680
    Top = 485
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = '&Edit'
    TabOrder = 11
    Visible = False
    OnClick = btnEditClick
  end
  object StatusBar1: TStatusBar
    Left = 0
    Top = 523
    Width = 773
    Height = 19
    Panels = <
      item
        Width = 225
      end
      item
        Width = 225
      end
      item
        Width = 225
      end
      item
        Width = 225
      end>
  end
  object chkFilterByYear: TCheckBox
    Left = 680
    Top = 301
    Width = 85
    Height = 17
    Anchors = [akTop, akRight]
    Caption = 'Filter by &Year'
    Enabled = False
    TabOrder = 13
    OnClick = chkFilterByYearClick
  end
  object rbBatchPrint: TRadioButton
    Left = 680
    Top = 79
    Width = 85
    Height = 17
    Anchors = [akTop, akRight]
    Caption = '&Batch Invoice'
    TabOrder = 14
    OnClick = rbBatchPrintClick
  end
  object btnExportPDF: TButton
    Left = 680
    Top = 454
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = 'Export PDF'
    TabOrder = 15
    OnClick = btnExportPDFClick
  end
  object btnEdit2: TButton
    Left = 680
    Top = 361
    Width = 75
    Height = 25
    Anchors = [akTop, akRight]
    Caption = 'Edit (no &RTF)'
    TabOrder = 16
    OnClick = btnEdit2Click
  end
  object chkFilterByMonth: TCheckBox
    Left = 680
    Top = 324
    Width = 93
    Height = 17
    Anchors = [akTop, akRight]
    Caption = 'Filter by &Month'
    Enabled = False
    TabOrder = 17
    OnClick = chkFilterByMonthClick
  end
  object rbQuotation: TRadioButton
    Left = 680
    Top = 125
    Width = 69
    Height = 17
    Anchors = [akTop, akRight]
    Caption = '&Quotation'
    TabOrder = 18
    OnClick = rbInvoiceClick
  end
  object RadioGroup1: TRadioGroup
    Left = 671
    Top = 159
    Width = 98
    Height = 73
    Anchors = [akTop, akRight]
    Caption = 'Filter Field'
    Enabled = False
    ItemIndex = 0
    Items.Strings = (
      'Date of Shoot'
      'Invoice Date')
    TabOrder = 19
    OnClick = RadioGroup1Click
  end
  object frxDBDataset1: TfrxDBDataset
    UserName = 'frxDBDataset1'
    CloseDataSource = False
    DataSet = DataModule1.qryPrintInvoice
    BCDToCurrency = False
    Left = 336
    Top = 128
  end
  object frxDBDataset2: TfrxDBDataset
    UserName = 'frxDBDataset2'
    CloseDataSource = False
    DataSet = DataModule1.fbPrintInvoiceDetails
    BCDToCurrency = False
    Left = 416
    Top = 128
  end
  object frxReport1: TfrxReport
    Version = '4.15'
    DotMatrixReport = False
    IniFile = '\Software\Fast Reports'
    PreviewOptions.Buttons = [pbPrint, pbLoad, pbSave, pbExport, pbZoom, pbFind, pbOutline, pbPageSetup, pbTools, pbEdit, pbNavigator, pbExportQuick]
    PreviewOptions.Zoom = 1.000000000000000000
    PrintOptions.Printer = 'Default'
    PrintOptions.PrintOnSheet = 0
    ReportOptions.CreateDate = 41103.727593819400000000
    ReportOptions.LastChange = 41761.772875277800000000
    ScriptLanguage = 'PascalScript'
    StoreInDFM = False
    OnGetValue = frxReport1GetValue
    OnUserFunction = frxReport1UserFunction
    Left = 336
    Top = 80
  end
  object frxRichObject1: TfrxRichObject
    Left = 552
    Top = 128
  end
  object frxPDFExport1: TfrxPDFExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    EmbeddedFonts = True
    PrintOptimized = False
    Outline = False
    Background = False
    HTMLTags = False
    Author = 'FastReport'
    Subject = 'FastReport PDF export'
    ProtectionFlags = [ePrint, eModify, eCopy, eAnnot]
    HideToolbar = False
    HideMenubar = False
    HideWindowUI = False
    FitWindow = False
    CenterWindow = False
    PrintScaling = False
    Left = 256
    Top = 184
  end
  object frxDBConfig: TfrxDBDataset
    UserName = 'frxDBDataset3'
    CloseDataSource = False
    DataSet = DataModule1.fbConfig
    BCDToCurrency = False
    Left = 256
    Top = 128
  end
  object frxMailExport1: TfrxMailExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    ShowExportDialog = True
    SmtpPort = 25
    UseIniFile = True
    TimeOut = 60
    ConfurmReading = False
    Left = 336
    Top = 184
  end
  object frxXLSExport1: TfrxXLSExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    ExportEMF = True
    AsText = False
    Background = True
    FastExport = True
    PageBreaks = True
    EmptyLines = True
    SuppressPageHeadersFooters = False
    Left = 416
    Top = 184
  end
  object frxRTFExport1: TfrxRTFExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    PictureType = gpPNG
    Wysiwyg = True
    Creator = 'FastReport'
    SuppressPageHeadersFooters = False
    HeaderFooterMode = hfText
    AutoSize = False
    Left = 512
    Top = 176
  end
  object frxODTExport1: TfrxODTExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    PictureType = gpPNG
    Background = True
    Creator = 'FastReport'
    Language = 'en'
    SuppressPageHeadersFooters = False
    Left = 592
    Top = 184
  end
  object frxODSExport1: TfrxODSExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    DataOnly = False
    PictureType = gpPNG
    Background = True
    Creator = 'FastReport'
    Language = 'en'
    SuppressPageHeadersFooters = False
    Left = 176
    Top = 184
  end
end
